package sg.edu.nus.iss.cats.dataaccess.hibernate;

public class HibernateConstants {
	// Configuration constants
	
	// Table names
	public static final String usersTableName = "User";

	public static final String employeesTableName = "Employee";

	public static final String rolesTableName = "Role";

	public static final String userRolesTableName = "UserRole";

	public static final String coursesTableName = "Course";

	public static final String courseEventsTableName = "CoursEevent";

	public static final String sequences = "sequences";

	public static final String departmentsTableName = "departments";

	// Users table field names
	public static final String u_userId = "userId";

	public static final String u_name = "name";

	public static final String u_password = "password";

	public static final String u_employeeId = "employeeId";

	// Employees table field names
	public static final String e_employeeId = "employeeId";

	public static final String e_name = "name";

	public static final String e_managerId = "managerId";

	// roles table field names
	public static final String r_roleId = "roleId";

	public static final String r_name = "name";

	public static final String r_description = "description";

	// user roles field names
	public static final String ur_userId = "userId";

	public static final String ur_roleId = "roleId";

	// Course table field names
	public static final String c_employeeId = "employeeId";

	public static final String c_courseId = "courseId";

	public static final String c_courseName = "courseName";

	public static final String c_organiser = "organiser";

	public static final String c_fromDate = "fromDate";

	public static final String c_toDate = "toDate";

	public static final String c_fees = "fees";

	public static final String c_gstincluded = "gstIncluded";

	public static final String c_justification = "justification";

	public static final String c_status = "status";

	// Course events
	public static final String ce_courseEventId = "courseEventId";

	public static final String ce_courseId = "courseId";

	public static final String ce_timestamp = "timestamp";

	public static final String ce_eventType = "eventType";

	public static final String ce_eventBy = "eventBy";

	public static final String ce_comment = "comment";

	// Sequence name
	public static final String seq_name = "name";

	public static final String last_value = "last_value";

	// Department
	public static final String d_departmentId = "departmentId";

	public static final String d_managerInCharge = "managerInCharge";

}